package com.py.credit.dao;

import com.py.credit.entity.QyRateNum;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

public interface DynamicMapDao {

	public List<QyRateNum> selectQyRateNum(@Param(value = "year")int year, @Param(value = "month")int month, @Param(value = "type")String type, @Param(value = "sort")String sort, @Param(value = "section")String section, @Param(value = "code")String code);
	
	public BigDecimal selectEITradeTendencyCount(@Param(value = "year") int year, @Param(value = "month") int month, @Param(value = "type")String type, @Param(value = "section")String section);
	

	public List<Map<String, Object>> getTradeVolume(@Param(value = "year") int year);

	public Integer getTradeVolumeRank(@Param(value = "year") int year, @Param(value = "section") String section) ;

	public Integer getTradeVolumeRankByType(@Param(value = "year") int year, @Param(value = "section") String section,  @Param(value = "type") String type );

	public List<Map<String, Object>> getProductTop5(@Param(value = "year") int year, @Param(value = "section") String section,  @Param(value = "type") String type );

	public List<Map<String, Object>> selectDictTypeChartCount(@Param(value = "year") int year,  @Param(value = "code") String code , @Param(value = "section") String section) ;
	
	public List<Map<String, Object>> getTradeCountryTop6(@Param(value = "year") int year, @Param(value = "section") String section, @Param(value = "type")String type);

	public List<Map<String, Object>> getProductInfo(@Param(value = "name")String name, @Param(value = "year") int year, @Param(value = "section") String section, @Param(value = "type")String type);

	public BigDecimal selectEITotalCount(@Param(value = "year") int year, @Param(value = "type")String type, @Param(value = "section") String section);

	public List<Map<String, Object>> selectCityTotalCount(@Param(value = "year") int year) ;

	public List<Map<String, Object>> selectCommodityTotalCount(@Param(value = "year") int year,@Param(value = "section")String section);
}
